SQL workspace – BigQuery – firstprojectBQ

Viewing pinned projects.

Enter to Rename, ⇧Enter to Preview

Schema

Details

Preview

Table schema

Field name	Type	Mode
iso_code	STRING	NULLABLE
continent	STRING	NULLABLE
location	STRING	NULLABLE
date	DATE	NULLABLE
population	INTEGER	NULLABLE
total_cases	INTEGER	NULLABLE
new_cases	INTEGER	NULLABLE
new_cases_smoothed	FLOAT	NULLABLE
total_deaths	INTEGER	NULLABLE
new_deaths	INTEGER	NULLABLE
new_deaths_smoothed	FLOAT	NULLABLE
total_cases_per_million	FLOAT	NULLABLE
new_cases_per_million	FLOAT	NULLABLE
new_cases_smoothed_per_million	FLOAT	NULLABLE
total_deaths_per_million	FLOAT	NULLABLE
new_deaths_per_million	FLOAT	NULLABLE
new_deaths_smoothed_per_million	FLOAT	NULLABLE
reproduction_rate	FLOAT	NULLABLE
icu_patients	INTEGER	NULLABLE
icu_patients_per_million	FLOAT	NULLABLE
hosp_patients	INTEGER	NULLABLE
hosp_patients_per_million	FLOAT	NULLABLE
weekly_icu_admissions	STRING	NULLABLE
weekly_icu_admissions_per_million	STRING	NULLABLE
weekly_hosp_admissions	STRING	NULLABLE
weekly_hosp_admissions_per_million	STRING	NULLABLE

Rows per page:

1 – 26 of 26

Schema

Details

Preview

Table schema

Field name	Type	Mode
iso_code	STRING	NULLABLE
continent	STRING	NULLABLE
location	STRING	NULLABLE
date	DATE	NULLABLE
string_field_4	STRING	NULLABLE
string_field_5	STRING	NULLABLE
string_field_6	STRING	NULLABLE
string_field_7	STRING	NULLABLE
string_field_8	STRING	NULLABLE
string_field_9	STRING	NULLABLE
string_field_10	STRING	NULLABLE
string_field_11	STRING	NULLABLE
string_field_12	STRING	NULLABLE
string_field_13	STRING	NULLABLE
string_field_14	STRING	NULLABLE
string_field_15	STRING	NULLABLE
string_field_16	STRING	NULLABLE
string_field_17	STRING	NULLABLE
string_field_18	STRING	NULLABLE
string_field_19	STRING	NULLABLE
string_field_20	STRING	NULLABLE
string_field_21	STRING	NULLABLE
string_field_22	STRING	NULLABLE
string_field_23	STRING	NULLABLE
string_field_24	STRING	NULLABLE
string_field_25	STRING	NULLABLE
new_tests	INTEGER	NULLABLE
total_tests	INTEGER	NULLABLE
total_tests_per_thousand	FLOAT	NULLABLE
new_tests_per_thousand	FLOAT	NULLABLE
new_tests_smoothed	INTEGER	NULLABLE
new_tests_smoothed_per_thousand	FLOAT	NULLABLE
positive_rate	FLOAT	NULLABLE
tests_per_case	FLOAT	NULLABLE
tests_units	STRING	NULLABLE
total_vaccinations	INTEGER	NULLABLE
people_vaccinated	INTEGER	NULLABLE
people_fully_vaccinated	INTEGER	NULLABLE
total_boosters	INTEGER	NULLABLE
new_vaccinations	INTEGER	NULLABLE
new_vaccinations_smoothed	INTEGER	NULLABLE
total_vaccinations_per_hundred	FLOAT	NULLABLE
people_vaccinated_per_hundred	FLOAT	NULLABLE
people_fully_vaccinated_per_hundred	FLOAT	NULLABLE
total_boosters_per_hundred	FLOAT	NULLABLE
new_vaccinations_smoothed_per_million	INTEGER	NULLABLE
new_people_vaccinated_smoothed	INTEGER	NULLABLE
new_people_vaccinated_smoothed_per_hundred	FLOAT	NULLABLE
stringency_index	FLOAT	NULLABLE
population_density	FLOAT	NULLABLE

Rows per page:

1 – 50 of 67

CREATE TABLE covid.PercentPopulationVaccinated

(

continent string,

location string,

date date,

population integer,

new_vaccinations integer,

RollingPeopleVaccinated integer

) AS

SELECT deaths.continent, deaths.location, deaths.date, deaths.population, vax.new_vaccinations,

SUM(vax.new_vaccinations) OVER (PARTITION BY deaths.location ORDER BY deaths.location, deaths.date) as RollingPeopleVaccinated,

FROM `firstprojectbq-336101.covid.coviddeaths` deaths

JOIN `firstprojectbq-336101.covid.covidvaccinations` vax

ON deaths.location = vax.location

AND deaths.date = vax.date

select *

from `firstprojectbq-336101.covid.PercentPopulationVaccinated`

Enter to Rename, ⇧Enter to Preview

Processing location: US

Query complete (1.3 sec elapsed, 6 MB processed)

Job information

Results

JSON

Execution details

Row	continent	location	date	population	new_vaccinations	RollingPeopleVaccinated
1	Asia	Afghanistan	2020-04-01	39835428	null	null
2	Asia	Afghanistan	2020-04-24	39835428	null	null
3	Asia	Afghanistan	2020-09-04	39835428	null	null
4	Asia	Afghanistan	2020-10-10	39835428	null	null
5	Asia	Afghanistan	2021-04-05	39835428	null	null
6	Asia	Afghanistan	2021-08-08	39835428	null	6874
7	Asia	Afghanistan	2021-09-02	39835428	null	6874
8	Asia	Afghanistan	2021-09-30	39835428	null	6874
9	Asia	Afghanistan	2021-10-03	39835428	null	6874
10	Asia	Afghanistan	2021-12-31	39835428	null	6874
11	Europe	Albania	2020-03-11	2872934	null	null
12	Europe	Albania	2020-05-17	2872934	null	null
13	Europe	Albania	2020-06-24	2872934	null	null
14	Europe	Albania	2020-09-10	2872934	null	null
15	Europe	Albania	2020-09-24	2872934	null	null
16	Europe	Albania	2020-09-26	2872934	null	null
17	Europe	Albania	2020-11-19	2872934	null	null
18	Europe	Albania	2020-11-29	2872934	null	null
19	Europe	Albania	2020-12-04	2872934	null	null
20	Europe	Albania	2020-12-10	2872934	null	null
21	Europe	Albania	2021-02-09	2872934	null	421
22	Europe	Albania	2021-03-13	2872934	null	2897
23	Europe	Albania	2021-04-16	2872934	10134	193976
24	Europe	Albania	2021-05-09	2872934	3234	447326
25	Europe	Albania	2021-05-22	2872934	null	529419
26	Europe	Albania	2021-07-08	2872934	5634	722918
27	Europe	Albania	2021-08-13	2872934	null	866614
28	Europe	Albania	2021-11-21	2872934	null	1306033
29	Europe	Albania	2021-12-07	2872934	10133	1343238
30	Africa	Algeria	2020-07-25	44616626	null	null
31	Africa	Algeria	2020-07-31	44616626	null	null
32	Africa	Algeria	2020-11-04	44616626	null	null
33	Africa	Algeria	2020-11-09	44616626	null	null
34	Africa	Algeria	2021-04-09	44616626	null	30
35	Africa	Algeria	2021-08-14	44616626	null	30
36	Africa	Algeria	2021-09-07	44616626	null	30
37	Africa	Algeria	2021-09-11	44616626	null	30
38	Africa	Algeria	2022-01-11	44616626	null	170786
39	Europe	Andorra	2020-05-17	77354	null	null
40	Europe	Andorra	2020-11-06	77354	null	null
41	Europe	Andorra	2020-12-05	77354	null	null
42	Europe	Andorra	2021-02-13	77354	null	null
43	Europe	Andorra	2021-02-14	77354	null	null
44	Europe	Andorra	2021-03-22	77354	null	null
45	Europe	Andorra	2021-03-30	77354	null	null
46	Europe	Andorra	2021-05-12	77354	null	4802
47	Europe	Andorra	2021-10-01	77354	null	4802
48	Europe	Andorra	2021-11-09	77354	null	4802
49	Europe	Andorra	2021-11-26	77354	null	4802
50	Europe	Andorra	2021-12-26	77354	null	4802
51	Europe	Andorra	2022-01-12	77354	null	4802
52	Europe	Andorra	2022-01-23	77354	null	4802
53	Africa	Angola	2020-03-20	33933611	null	null
54	Africa	Angola	2020-10-12	33933611	null	null
55	Africa	Angola	2020-11-19	33933611	null	null
56	Africa	Angola	2021-03-05	33933611	null	null
57	Africa	Angola	2021-04-23	33933611	null	null
58	Africa	Angola	2021-07-28	33933611	null	null
59	Africa	Angola	2022-01-20	33933611	null	null
60	Africa	Angola	2022-02-14	33933611	null	null
61	North America	Anguilla	2020-07-10	15125	null	null
62	North America	Anguilla	2020-10-24	15125	null	null
63	North America	Anguilla	2020-10-26	15125	null	null
64	North America	Anguilla	2021-02-03	15125	null	null
65	North America	Anguilla	2021-05-08	15125	null	1421
66	North America	Anguilla	2021-08-13	15125	null	1421
67	North America	Anguilla	2021-12-02	15125	null	1421
68	North America	Anguilla	2022-02-08	15125	null	1421
69	North America	Antigua and Barbuda	2020-07-02	98728	null	null
70	North America	Antigua and Barbuda	2020-07-17	98728	null	null
71	North America	Antigua and Barbuda	2020-07-20	98728	null	null
72	North America	Antigua and Barbuda	2020-08-18	98728	null	null
73	North America	Antigua and Barbuda	2020-09-03	98728	null	null
74	North America	Antigua and Barbuda	2020-10-06	98728	null	null
75	North America	Antigua and Barbuda	2020-11-18	98728	null	null
76	North America	Antigua and Barbuda	2021-01-22	98728	null	null
77	North America	Antigua and Barbuda	2021-02-03	98728	null	null
78	North America	Antigua and Barbuda	2021-03-12	98728	null	null
79	North America	Antigua and Barbuda	2021-05-12	98728	null	225
80	North America	Antigua and Barbuda	2021-05-19	98728	null	225
81	North America	Antigua and Barbuda	2021-05-22	98728	null	225
82	North America	Antigua and Barbuda	2021-06-22	98728	null	5841
83	North America	Antigua and Barbuda	2021-08-29	98728	null	7675
84	North America	Antigua and Barbuda	2021-11-24	98728	null	8107
85	North America	Antigua and Barbuda	2021-12-01	98728	null	8107
86	North America	Antigua and Barbuda	2021-12-31	98728	null	8107
87	North America	Antigua and Barbuda	2022-01-26	98728	null	8107
88	South America	Argentina	2020-03-21	45605823	null	null
89	South America	Argentina	2020-04-03	45605823	null	null
90	South America	Argentina	2020-09-04	45605823	null	null
91	South America	Argentina	2021-02-24	45605823	33840	474979
92	South America	Argentina	2021-04-08	45605823	199395	4297256
93	South America	Argentina	2021-05-20	45605823	165596	10075563
94	South America	Argentina	2021-06-25	45605823	284128	18731850
95	South America	Argentina	2021-08-15	45605823	253797	35653020
96	South America	Argentina	2021-09-20	45605823	187362	48028894
97	South America	Argentina	2021-12-09	45605823	null	65734432
98	South America	Argentina	2022-02-20	45605823	null	81057935
99	Asia	Armenia	2020-02-26	2968128	null	null
100	Asia	Armenia	2020-05-03	2968128	null	null

Rows per page:

1 - 100 of 153531

First page

Last page

 [
  {
    "continent": "Asia",
    "location": "Afghanistan",
    "date": "2020-04-01",
    "population": "39835428",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Afghanistan",
    "date": "2020-04-24",
    "population": "39835428",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Afghanistan",
    "date": "2020-09-04",
    "population": "39835428",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Afghanistan",
    "date": "2020-10-10",
    "population": "39835428",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Afghanistan",
    "date": "2021-04-05",
    "population": "39835428",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Afghanistan",
    "date": "2021-08-08",
    "population": "39835428",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "6874"
  },
  {
    "continent": "Asia",
    "location": "Afghanistan",
    "date": "2021-09-02",
    "population": "39835428",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "6874"
  },
  {
    "continent": "Asia",
    "location": "Afghanistan",
    "date": "2021-09-30",
    "population": "39835428",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "6874"
  },
  {
    "continent": "Asia",
    "location": "Afghanistan",
    "date": "2021-10-03",
    "population": "39835428",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "6874"
  },
  {
    "continent": "Asia",
    "location": "Afghanistan",
    "date": "2021-12-31",
    "population": "39835428",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "6874"
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2020-03-11",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2020-05-17",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2020-06-24",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2020-09-10",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2020-09-24",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2020-09-26",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2020-11-19",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2020-11-29",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2020-12-04",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2020-12-10",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2021-02-09",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "421"
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2021-03-13",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "2897"
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2021-04-16",
    "population": "2872934",
    "new_vaccinations": "10134",
    "RollingPeopleVaccinated": "193976"
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2021-05-09",
    "population": "2872934",
    "new_vaccinations": "3234",
    "RollingPeopleVaccinated": "447326"
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2021-05-22",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "529419"
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2021-07-08",
    "population": "2872934",
    "new_vaccinations": "5634",
    "RollingPeopleVaccinated": "722918"
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2021-08-13",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "866614"
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2021-11-21",
    "population": "2872934",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "1306033"
  },
  {
    "continent": "Europe",
    "location": "Albania",
    "date": "2021-12-07",
    "population": "2872934",
    "new_vaccinations": "10133",
    "RollingPeopleVaccinated": "1343238"
  },
  {
    "continent": "Africa",
    "location": "Algeria",
    "date": "2020-07-25",
    "population": "44616626",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Africa",
    "location": "Algeria",
    "date": "2020-07-31",
    "population": "44616626",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Africa",
    "location": "Algeria",
    "date": "2020-11-04",
    "population": "44616626",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Africa",
    "location": "Algeria",
    "date": "2020-11-09",
    "population": "44616626",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Africa",
    "location": "Algeria",
    "date": "2021-04-09",
    "population": "44616626",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "30"
  },
  {
    "continent": "Africa",
    "location": "Algeria",
    "date": "2021-08-14",
    "population": "44616626",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "30"
  },
  {
    "continent": "Africa",
    "location": "Algeria",
    "date": "2021-09-07",
    "population": "44616626",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "30"
  },
  {
    "continent": "Africa",
    "location": "Algeria",
    "date": "2021-09-11",
    "population": "44616626",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "30"
  },
  {
    "continent": "Africa",
    "location": "Algeria",
    "date": "2022-01-11",
    "population": "44616626",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "170786"
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2020-05-17",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2020-11-06",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2020-12-05",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2021-02-13",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2021-02-14",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2021-03-22",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2021-03-30",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2021-05-12",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "4802"
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2021-10-01",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "4802"
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2021-11-09",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "4802"
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2021-11-26",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "4802"
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2021-12-26",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "4802"
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2022-01-12",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "4802"
  },
  {
    "continent": "Europe",
    "location": "Andorra",
    "date": "2022-01-23",
    "population": "77354",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "4802"
  },
  {
    "continent": "Africa",
    "location": "Angola",
    "date": "2020-03-20",
    "population": "33933611",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Africa",
    "location": "Angola",
    "date": "2020-10-12",
    "population": "33933611",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Africa",
    "location": "Angola",
    "date": "2020-11-19",
    "population": "33933611",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Africa",
    "location": "Angola",
    "date": "2021-03-05",
    "population": "33933611",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Africa",
    "location": "Angola",
    "date": "2021-04-23",
    "population": "33933611",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Africa",
    "location": "Angola",
    "date": "2021-07-28",
    "population": "33933611",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Africa",
    "location": "Angola",
    "date": "2022-01-20",
    "population": "33933611",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Africa",
    "location": "Angola",
    "date": "2022-02-14",
    "population": "33933611",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Anguilla",
    "date": "2020-07-10",
    "population": "15125",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Anguilla",
    "date": "2020-10-24",
    "population": "15125",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Anguilla",
    "date": "2020-10-26",
    "population": "15125",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Anguilla",
    "date": "2021-02-03",
    "population": "15125",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Anguilla",
    "date": "2021-05-08",
    "population": "15125",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "1421"
  },
  {
    "continent": "North America",
    "location": "Anguilla",
    "date": "2021-08-13",
    "population": "15125",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "1421"
  },
  {
    "continent": "North America",
    "location": "Anguilla",
    "date": "2021-12-02",
    "population": "15125",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "1421"
  },
  {
    "continent": "North America",
    "location": "Anguilla",
    "date": "2022-02-08",
    "population": "15125",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "1421"
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2020-07-02",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2020-07-17",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2020-07-20",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2020-08-18",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2020-09-03",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2020-10-06",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2020-11-18",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2021-01-22",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2021-02-03",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2021-03-12",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2021-05-12",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "225"
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2021-05-19",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "225"
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2021-05-22",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "225"
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2021-06-22",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "5841"
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2021-08-29",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "7675"
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2021-11-24",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "8107"
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2021-12-01",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "8107"
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2021-12-31",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "8107"
  },
  {
    "continent": "North America",
    "location": "Antigua and Barbuda",
    "date": "2022-01-26",
    "population": "98728",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "8107"
  },
  {
    "continent": "South America",
    "location": "Argentina",
    "date": "2020-03-21",
    "population": "45605823",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "South America",
    "location": "Argentina",
    "date": "2020-04-03",
    "population": "45605823",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "South America",
    "location": "Argentina",
    "date": "2020-09-04",
    "population": "45605823",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "South America",
    "location": "Argentina",
    "date": "2021-02-24",
    "population": "45605823",
    "new_vaccinations": "33840",
    "RollingPeopleVaccinated": "474979"
  },
  {
    "continent": "South America",
    "location": "Argentina",
    "date": "2021-04-08",
    "population": "45605823",
    "new_vaccinations": "199395",
    "RollingPeopleVaccinated": "4297256"
  },
  {
    "continent": "South America",
    "location": "Argentina",
    "date": "2021-05-20",
    "population": "45605823",
    "new_vaccinations": "165596",
    "RollingPeopleVaccinated": "10075563"
  },
  {
    "continent": "South America",
    "location": "Argentina",
    "date": "2021-06-25",
    "population": "45605823",
    "new_vaccinations": "284128",
    "RollingPeopleVaccinated": "18731850"
  },
  {
    "continent": "South America",
    "location": "Argentina",
    "date": "2021-08-15",
    "population": "45605823",
    "new_vaccinations": "253797",
    "RollingPeopleVaccinated": "35653020"
  },
  {
    "continent": "South America",
    "location": "Argentina",
    "date": "2021-09-20",
    "population": "45605823",
    "new_vaccinations": "187362",
    "RollingPeopleVaccinated": "48028894"
  },
  {
    "continent": "South America",
    "location": "Argentina",
    "date": "2021-12-09",
    "population": "45605823",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "65734432"
  },
  {
    "continent": "South America",
    "location": "Argentina",
    "date": "2022-02-20",
    "population": "45605823",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "81057935"
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2020-02-26",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2020-05-03",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2020-07-01",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2020-09-21",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2020-10-10",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2021-01-10",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2021-03-04",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2021-03-09",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2021-03-20",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2021-09-05",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2021-11-12",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2022-01-08",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Armenia",
    "date": "2022-02-10",
    "population": "2968128",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2020-03-17",
    "population": "107195",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2020-05-24",
    "population": "107195",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2020-05-29",
    "population": "107195",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2020-06-11",
    "population": "107195",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2020-10-21",
    "population": "107195",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2020-10-28",
    "population": "107195",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2020-11-03",
    "population": "107195",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2020-11-24",
    "population": "107195",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2021-03-21",
    "population": "107195",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2021-04-18",
    "population": "107195",
    "new_vaccinations": "69",
    "RollingPeopleVaccinated": "12578"
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2021-05-06",
    "population": "107195",
    "new_vaccinations": "51",
    "RollingPeopleVaccinated": "34309"
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2021-07-13",
    "population": "107195",
    "new_vaccinations": "371",
    "RollingPeopleVaccinated": "81928"
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2021-10-19",
    "population": "107195",
    "new_vaccinations": "221",
    "RollingPeopleVaccinated": "101906"
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2021-11-21",
    "population": "107195",
    "new_vaccinations": "87",
    "RollingPeopleVaccinated": "104098"
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2021-12-23",
    "population": "107195",
    "new_vaccinations": "141",
    "RollingPeopleVaccinated": "105660"
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2022-01-06",
    "population": "107195",
    "new_vaccinations": "147",
    "RollingPeopleVaccinated": "106129"
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2022-01-17",
    "population": "107195",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "106531"
  },
  {
    "continent": "North America",
    "location": "Aruba",
    "date": "2022-01-25",
    "population": "107195",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "107810"
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2020-02-01",
    "population": "25788217",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2020-05-01",
    "population": "25788217",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2020-05-17",
    "population": "25788217",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2020-05-28",
    "population": "25788217",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2020-05-30",
    "population": "25788217",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2020-06-07",
    "population": "25788217",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2020-08-24",
    "population": "25788217",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2021-01-18",
    "population": "25788217",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2021-06-14",
    "population": "25788217",
    "new_vaccinations": "63946",
    "RollingPeopleVaccinated": "5487186"
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2021-08-14",
    "population": "25788217",
    "new_vaccinations": "164561",
    "RollingPeopleVaccinated": "14776798"
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2021-09-29",
    "population": "25788217",
    "new_vaccinations": "307852",
    "RollingPeopleVaccinated": "27251623"
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2021-11-04",
    "population": "25788217",
    "new_vaccinations": "194415",
    "RollingPeopleVaccinated": "35935018"
  },
  {
    "continent": "Oceania",
    "location": "Australia",
    "date": "2022-01-22",
    "population": "25788217",
    "new_vaccinations": "190758",
    "RollingPeopleVaccinated": "47445579"
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2020-03-31",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2020-07-07",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2020-07-26",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2020-08-08",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2020-08-13",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2020-09-16",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2020-11-02",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2020-12-03",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2021-02-10",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2021-03-21",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2021-04-12",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2021-04-29",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2021-10-03",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2021-10-05",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2021-10-26",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Europe",
    "location": "Austria",
    "date": "2021-11-14",
    "population": "9043072",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2020-03-11",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2020-03-24",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2020-04-12",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2020-09-29",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2020-12-12",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2021-01-10",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2021-01-19",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2021-01-25",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2021-02-03",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2021-02-09",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2021-02-14",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2021-08-05",
    "population": "10223344",
    "new_vaccinations": "63623",
    "RollingPeopleVaccinated": "4203241"
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2021-11-04",
    "population": "10223344",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "7593339"
  },
  {
    "continent": "Asia",
    "location": "Azerbaijan",
    "date": "2021-12-16",
    "population": "10223344",
    "new_vaccinations": "30303",
    "RollingPeopleVaccinated": "8611468"
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2020-03-20",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2020-06-24",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2020-07-05",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2020-07-07",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2020-07-23",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2020-07-25",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2020-09-06",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2020-10-22",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2020-11-22",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2020-12-03",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2021-01-09",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2021-01-26",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2021-02-17",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2021-02-28",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2021-03-22",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "110"
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2021-06-07",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "110"
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2021-06-12",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "110"
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2021-10-10",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "2487"
  },
  {
    "continent": "North America",
    "location": "Bahamas",
    "date": "2022-01-05",
    "population": "396914",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": "9258"
  },
  {
    "continent": "Asia",
    "location": "Bahrain",
    "date": "2020-03-25",
    "population": "1748295",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Bahrain",
    "date": "2020-03-26",
    "population": "1748295",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Bahrain",
    "date": "2020-04-05",
    "population": "1748295",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Bahrain",
    "date": "2020-05-16",
    "population": "1748295",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Bahrain",
    "date": "2020-06-26",
    "population": "1748295",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Bahrain",
    "date": "2020-11-23",
    "population": "1748295",
    "new_vaccinations": null,
    "RollingPeopleVaccinated": null
  },
  {
    "continent": "Asia",
    "location": "Bahrain",
    "date": "2021-01-01",
    "population": "1748295",
    "new_vaccinations": "708",
    "RollingPeopleVaccinated": "20386"
  },
  {
    "continent": "Asia",
    "location": "Bahrain",
    "date": "2021-03-17",
    "population": "1748295",
    "new_vaccinations": "16907",
    "RollingPeopleVaccinated": "149738"
  },
  {
    "continent": "Asia",
    "location": "Bahrain",
    "date": "2021-04-23",
    "population": "1748295",
    "new_vaccinations": "7173",
    "RollingPeopleVaccinated": "709098"
  }
]

Results truncated. To see full results, click SAVE RESULTS above.

Query completed in 1.265 sec

2:18 PM

Open query in editor

xxxxxxxxxx

Job ID

firstprojectbq-336101:US.bquxjob_5cd9e016_17f23158355

User

ztvalentino98@gmail.com

Location

United States (US)

Creation time

Feb 22, 2022, 2:18:07 PM

Start time

Feb 22, 2022, 2:18:07 PM

End time

Feb 22, 2022, 2:18:08 PM

Duration

1.3 sec

Bytes processed

5.96 MB

Bytes billed

10 MB

Job priority

INTERACTIVE

Destination table

Temporary table

Use legacy SQL

false

Session ID

For help debugging or optimizing your query, check our documentation. Learn more

Elapsed time

1.3 sec
Slot time consumed

0.615 sec
Bytes shuffled

6.1 MB
Bytes spilled to disk

0 B

		Worker timing
Stages		Wait	Read	Compute	Write		Rows
S00: Input	Avg:	26 ms	52 ms	111 ms	8 ms	Input:	153,531
	Max:	26 ms	52 ms	111 ms	8 ms	Output:	153,531
S01: Output	Avg:	130 ms	0 ms	339 ms	68 ms	Input:	153,531
	Max:	130 ms	0 ms	339 ms	68 ms	Output:	153,531

Schema

Details

Preview

Row	continent	location	date	population	new_vaccinations	RollingPeopleVaccinated
1	Asia	Afghanistan	2020-04-01	39835428	-	-
2	Asia	Afghanistan	2020-04-24	39835428	-	-
3	Asia	Afghanistan	2020-09-04	39835428	-	-
4	Asia	Afghanistan	2020-10-10	39835428	-	-
5	Asia	Afghanistan	2021-04-05	39835428	-	-
6	Asia	Afghanistan	2021-08-08	39835428	-	6874
7	Asia	Afghanistan	2021-09-02	39835428	-	6874
8	Asia	Afghanistan	2021-09-30	39835428	-	6874
9	Asia	Afghanistan	2021-10-03	39835428	-	6874
10	Asia	Afghanistan	2021-12-31	39835428	-	6874
11	Europe	Albania	2020-03-11	2872934	-	-
12	Europe	Albania	2020-05-17	2872934	-	-
13	Europe	Albania	2020-06-24	2872934	-	-
14	Europe	Albania	2020-09-10	2872934	-	-
15	Europe	Albania	2020-09-24	2872934	-	-
16	Europe	Albania	2020-09-26	2872934	-	-
17	Europe	Albania	2020-11-19	2872934	-	-
18	Europe	Albania	2020-11-29	2872934	-	-
19	Europe	Albania	2020-12-04	2872934	-	-
20	Europe	Albania	2020-12-10	2872934	-	-
21	Europe	Albania	2021-02-09	2872934	-	421
22	Europe	Albania	2021-03-13	2872934	-	2897
23	Europe	Albania	2021-04-16	2872934	10134	193976
24	Europe	Albania	2021-05-09	2872934	3234	447326
25	Europe	Albania	2021-05-22	2872934	-	529419
26	Europe	Albania	2021-07-08	2872934	5634	722918
27	Europe	Albania	2021-08-13	2872934	-	866614
28	Europe	Albania	2021-11-21	2872934	-	1306033
29	Europe	Albania	2021-12-07	2872934	10133	1343238
30	Africa	Algeria	2020-07-25	44616626	-	-
31	Africa	Algeria	2020-07-31	44616626	-	-
32	Africa	Algeria	2020-11-04	44616626	-	-
33	Africa	Algeria	2020-11-09	44616626	-	-
34	Africa	Algeria	2021-04-09	44616626	-	30
35	Africa	Algeria	2021-08-14	44616626	-	30
36	Africa	Algeria	2021-09-07	44616626	-	30
37	Africa	Algeria	2021-09-11	44616626	-	30
38	Africa	Algeria	2022-01-11	44616626	-	170786
39	Europe	Andorra	2020-05-17	77354	-	-
40	Europe	Andorra	2020-11-06	77354	-	-
41	Europe	Andorra	2020-12-05	77354	-	-
42	Europe	Andorra	2021-02-13	77354	-	-
43	Europe	Andorra	2021-02-14	77354	-	-
44	Europe	Andorra	2021-03-22	77354	-	-
45	Europe	Andorra	2021-03-30	77354	-	-
46	Europe	Andorra	2021-05-12	77354	-	4802
47	Europe	Andorra	2021-10-01	77354	-	4802
48	Europe	Andorra	2021-11-09	77354	-	4802
49	Europe	Andorra	2021-11-26	77354	-	4802
50	Europe	Andorra	2021-12-26	77354	-	4802

Results per page:

1 – 50 of 153531

sandbox

Set up billing to upgrade to the full BigQuery experience. Learn more

Explorer

coviddeaths

Table schema

covidvaccinations

Table schema

Query results

PercentPopulationVaccinated